Qid Examcode Question Qimpath opt1 opt2 opt3 opt4 opt5 opt6 opt7 opt8 opt9 opt10 opt11 opt12 opt13 opt14 opt15 impath1 impath2 impath3 impath4 impath5 impath6 impath7 impath8 impath9 impath10 impath11 impath12 impath13 impath14 impath15 answers uanswer CR Edit Delete
126 1Z0-066 answer edit delete
125 1Z0-066 answer edit delete
124 1Z0-066 answer edit delete
123 1Z0-066 answer edit delete
122 1Z0-066 answer edit delete
121 1Z0-066 answer edit delete
120 1Z0-066 answer edit delete
119 1Z0-066 answer edit delete
118 1Z0-066 answer edit delete
117 1Z0-066 answer edit delete
116 1Z0-066 answer edit delete
115 1Z0-066 answer edit delete
114 1Z0-066 answer edit delete
113 1Z0-066 answer edit delete
112 1Z0-066 answer edit delete
111 1Z0-066 answer edit delete
110 1Z0-066 answer edit delete
109 1Z0-066 answer edit delete
108 1Z0-066 answer edit delete
107 1Z0-066 answer edit delete
106 1Z0-066 answer edit delete
105 1Z0-066 answer edit delete
104 1Z0-066 answer edit delete
103 1Z0-066 answer edit delete
102 1Z0-066 answer edit delete
101 1Z0-066 answer edit delete
100 1Z0-066 answer edit delete
99 1Z0-066 answer edit delete
98 1Z0-066 answer edit delete
97 1Z0-066 answer edit delete
96 1Z0-066 answer edit delete
95 1Z0-066 answer edit delete
94 1Z0-066 answer edit delete
93 1Z0-066 answer edit delete
92 1Z0-066 answer edit delete
91 1Z0-066 answer edit delete
90 1Z0-066 answer edit delete
89 1Z0-066 answer edit delete
88 0 answer edit delete
87 (SELECT CO answer edit delete
86 1Z0-066 AN answer edit delete
85 1Z0-066) A answer edit delete
84 (SELECT (C answer edit delete
83 (SELECT (C answer edit delete
82 1Z0-066 AN answer edit delete
81 1Z0-066 AN answer edit delete
80 0 answer edit delete
79 0 answer edit delete
78 1 answer edit delete
77 0 answer edit delete
76 1Z0-066 AN answer edit delete
75 1Z0-066 AN answer edit delete
74 1Z0-066) A answer edit delete
73 1Z0-066) A answer edit delete
72 9509 answer edit delete
71 1Z0-066 answer edit delete
70 1Z0-066 answer edit delete
69 1Z0-066 answer edit delete
68 1Z0-066 answer edit delete
67 1Z0-066 answer edit delete
66 1Z0-066 answer edit delete
65 1Z0-066 Your Data Guard environment has a remote physical standby database with real-time query enabled, which is used for reporting, and a logical standby database used for DSS reporting. 65-quedg.png Client TNS entries for the databases use the correct service names for the intended service. A service name is registered with the local listener of each database instance. Oracle Net connectivity to the primary database instance must be established on all the standby database instances. The LOCAL_LISTENER parameter on the primary database instance must always be set. The standby database services must be defined statically with the Listeners running on the standby database hosts. The DB_NAME and DB_UNIQUE_NAME parameters must be set to the same value for all the databases in the Data Guard environment. The client applications must use the correct TNS entries when requesting connections to the database instances. 3, 4, 7 MC edit delete
64 1Z0-066 Which two statements are true about Far Sync instances? (Choose two.) They work in Maximum Availability mode. They work in Maximum Performance mode. They work in Maximum Protection mode. They do not work with Logical Standby databases. They do not work with Snapshot Standby databases. 1, 3 MC edit delete
63 1Z0-066 Which two are true concerning the configuring of Flashback database in a Data Guard environment? (Choose two.) It enables the use of far sync instances. It is a prerequisite for the use of Fast Start Failover. It permits a primary database that was disabled after failover to be reinstated as a standby. It permits a physical standby database to be converted to a snapshot standby database. It is required in order for a snapshot standby database to be converted to a physical database. 1, 2 MC edit delete
62 1Z0-066 Examine this command executed on a physical standby database to transition it to a logical standby database: 62-quedg.png FLASHBACK is automatically enabled when transitioning to the logical standby database. The Managed Recovery Process (MRPO) continues applying redo up to the SCN immediately preceding the redo corresponding to the LogMiner dictionary build. Supplemental logging will be enabled on the logical standby database when the physical database is transitioned to the logical standby database. SQL apply is automatically started when transitioning to the logical standby database. It will automatically start redo apply. 5 SC edit delete
61 1Z0-066 Which three statements are true about Data Guard database modes and states? (Choose three.) A primary database may ship redo directly to more than mine standby databases. Force Logging Mode is not required for a primary database but is recommended. A Logical Standby Database can be in MOUNT state while applying changes. The Primary Database can operate in noarchivelog mode. Databases in a Data Guard Configuration need not operate in Flashback Logging mode. 1, 2, 3 MC edit delete
60 1Z0-066 Which two are true about the creation of a Data Guard Broker configuration? (Choose two.) In a broker configuration, the primary database name must match the DB_UNIQUE_NAME value in the database initialization parameter file. A primary database profile may be added to the configuration prior to creating the primary database. A standby database profile may be added to the configuration prior to creating that standby database. A newly created broker configuration requires at least one standby database profile to be specified at the time the configuration is created. A newly created broker configuration is in the disabled state. 4, 5 MC edit delete
59 1Z0-066 Which three are true concerning database states after a successful switchover? (Choose three.) If the former primary database became a logical standby database it will be in mount state. The new primary database will be open read-write. The former primary database will always be open. If the former primary database became a logical standby database it will be open read-write. If the former primary database became a physical standby database it will always be open read-only. If the former primary database became a physical standby database it will be in the same state as the former physical standby database. 1, 2, 5 MC edit delete
58 1Z0-066 You have a Data Guard Broker configuration called ‘Somewhere’ as shown: 58-quedg.png A far sync instance cannot have inconsistent properties because it has no database. It shows all properties whose broker configuration values for database Nearby are inconsistent with the broker configuration values for database Farout. It shows all properties whose broker configuration values for database Nearby are inconsistent with the values in the corresponding server parameter file or the runtime values for database instance Nearby. Any inconsistency reported is on an instance-specific basis. 3, 4 MC edit delete
57 1Z0-066 Which two Data Guard features require the use of flashback database by the broker? (Choose two.) Read-Mostly physical standby implementations Far Sync Instances Fast-Start Failover Real Time Query Snapshot Standby databases 3, 5 MC edit delete
56 1Z0-066 Which two Data Guard monitoring activities may be performed using Enterprise Manager Cloud Control? (Choose two.) monitoring the redo apply rate on a physical standby monitoring the redo apply rate on a logical standby monitoring the undo generation rate on a logical standby monitoring the redo apply rate on a snapshot standby monitoring the transport lag monitoring the undo generation rate on the primary 1, 5 MC edit delete
55 1Z0-066 Your Data Guard environment consists of these components and settings: 55-quedg.png Change the protection mode to Maximum Performance. Increase the size of the buffer cache on the standby database instance. Reduce I/O latency for the storage used by the primary database. Change the protection mode to Maximum Protection. Increase the network bandwidth between the primary and standby databases. Increase the number of standby redo log files on the primary database. 1, 5 MC edit delete
54 1Z0-066 Examine the Data Guard configuration: 54-quedg.png The FastStartFailoverTarget property is not set on Sheep. The FastStartFailoverTarget property is not set on Dogs. The FastStartFailoverTarget property is not set on DogsFS1. The LogXptMode property is set to ASYNC on Dogs. The RedoRoutes property is not set on Dogs. The RedoRoutes property is not set on DogsFS1. 1, 4 MC edit delete
53 1Z0-066 Which two are true about rolling release upgrades in a Data Guard environment? (Choose two.) The background process DMON must be enabled on the primary and standby databases during a rolling release upgrade procedure. A physical standby database can be converted to a logical standby database temporarily. Rolling release upgrades require the background process RVWR to write flashback logs on the standby database. The KEEP IDENTITY clause ensures that a logical standby database keeps the same DBID as the primary database. The recovery point objective increases proportionally to the duration of the rolling release upgrade procedure. 2, 4 MC edit delete
52 1Z0-066 Examine the Data Guard configuration: 52-quedg.png Dogs will be an enabled logical standby database. Sheep will be the primary database. Cats will be a disabled physical standby database. Dogs will be a disabled logical standby database. Cats will be an enabled physical standby database. 1, 2, 3 MC edit delete
51 1Z0-066 You edit the DGConnectIdentifier database property using the edit database set property DGMGRL command. Which two are effects of this change? (Choose two.) The fal_client database initialization parameter on all standby databases is updated with the new value. The service attribute of the log_archive_dest_n initialization parameter for any database referring to the specified database is updated with the new value. The fal_client database initialization parameter for the specified database is updated with the new value. The broker configuration must be disabled and then enabled to use the new connection property. The service attribute of the log_archive_dest_n initialization parameter referring to all standby databases is updated with the new value. 1, 2 MC edit delete
50 1Z0-066 Which three factors can influence the rate of redo apply on a physical standby database? (Choose three.) The network latency between the primary and standby databases The number of archiver processes on the standby database The number and size of standby redo logs on the primary database The rate of redo generation on the primary database The number and size of standby redo logs on the standby database 1, 2, 5 MC edit delete
49 1Z0-066 You must configure an Oracle Data Guard environment consisting of: SYNC AFFIRM and Maximum Protection SYNC NOAFFIRM and Maximum Protection SYNC AFFIRM and Maximum Availability SYNC NOAFFIRM and Maximum Availability ASYNC and Maximum Performance 3 SC edit delete
48 1Z0-066 Which four statements are true regarding SQL Apply filters for a logical standby database? (Choose four.) They can be used to skip execution of DML triggers on a table while allowing the DML to execute. They can be used to skip ALTER SYSTEM and ALTER DATABASE commands. They can be used to stop SQL apply if it encounters an error. They can be used to skip all SQL statements executed on a specific pluggable database (PDB) within a standby multitenant container database (CDB). They can only be used to skip DML statements on a table. They can be used to skip ALTER TABLE commands on a specific tables. They can be used to skip CREATE TABLE commands. 1, 3, 6, 7 MC edit delete
47 1Z0-066 You must configure an Oracle Data Guard environment consisting of: 47-quedg.png SYNC AFFIRM and Maximum Protection SYNC NOAFFIRM and Maximum Protection SYNC AFFIRM and Maximum Availability SYNC NOAFFIRM and Maximum Availability ASYNC and Maximum Performance 3 SC edit delete
46 1Z0-066 Examine the Data Guard configuration: 46-quedg.png The observer must run on host ol5.example.com and is currently not running. The observer will reinstate Sheep automatically after a failover, if required. The observer will mark another standby database as the failover target if the original failover target becomes unavailable. The observer will detect if the primary database is unable to accept new connections. The former primary database will not be reinstated automatically after a failover. 2, 5 MC edit delete
45 1Z0-066 A Data Guard environment has this configuration and these attributes: 45-quedg.png Sdbd can still apply redo. The recovery point objective increases. The protection mode is lowered to maximum performance. The recovery time objective increases. Sbdb can still receive redo 4, 5 MC edit delete
44 1Z0-066 Which three are among the various tasks performed by the Data Guard Monitor (DMON) process? (Choose three.) performing role transitions when switchover requests are made communicating with DMON processes in other database instances that are part of the broker configuration activating role-based services appropriately in the various database instances of the configuration, based on the database role communicating with the DMON process of the observer to monitor a primary database in case a fast start failover is required. maintaining information about all members of the broker configuration in binary configuration files 1, 2, 5 MC edit delete
43 1Z0-066 Examine the Data Guard configuration after an accidental switchover to Sheep: 43-quedg.png Sheep will be a disabled logical standby database. Sheep will be an enabled logical standby database. Cats will be a disabled physical standby database that can be manually enabled. Cats will be an enabled physical standby database. Dogs will be the primary database. 2, 3, 5 MC edit delete
42 1Z0-066 Which two statements are true for Data Guard environments with multi-tenant databases? (Choose two.) Different pluggable databases within a logical standby database may have different guard statuses. The Data Guard broker automatically always opens the pluggable databases of a standby database after a role change operation. The Data Guard broker automatically opens all pluggable databases of a primary database a role change operation. The CDBDBA privilege must be used instead of the SYSDBA privilege for connections as SYS to the root container of a multi-tenant standby database. A multi-tenant standby database can have fewer pluggable databases than the primary container database. 3, 4 MC edit delete
41 1Z0-066 Which two are true about offloading backups to a physical standby database in a Data Guard environment? (Choose two.) The standby database must be registered in an RMAN catalog after the primary database has been registered. The standby database cannot be registered in an RMAN catalog if the primary database has not been registered. Backups of the standby control file taken while connected to the catalog where the database is registered, may be used to restore the control file on the primary database. The standby database must be registered in an RMAN catalog before the primary database has been registered. 2, 3 MC edit delete
40 1Z0-066 Which four are true about DGMGRL show command? (Choose four.) It can be used to show properties of a pluggable standby database. It can be used to show properties of a pluggable primary database. It can be used to show instance-specific properties for a RAC database. It can be used to show properties of a far sync instance. It can be used to show Fast Start Failover properties. It can be used to show properties of a primary container database. 1, 2, 5, 6 MC edit delete
39 1Z0-066 Examine the Data Guard configuration: 39-quedg.png Sheep will be in the disabled state. Sheep will be in the enabled state. Dogs will be in the disabled state and has to be manually reinstated. The configuration will be in Maximum Performance mode. The configuration will be in Maximum Availability mode. 2, 3, 4 MC edit delete
38 1Z0-066 Your Data Guard environment consists of these components and settings: 38-quedg.png It can only be enabled for a configuration in Maximum Performance mode. It allows user errors on the primary to be recovered by using the physical standby database. It enables you to bypass the default network timeout interval specified for the standby redo transport destination. It can only be enabled for a configuration in Maximum Availability mode. It allows logical corruptions on the primary to be recovered by using the physical standby database. It specifies a delay before the primary ships redo to the standby destination having DelayMins set. 2, 6 MC edit delete
37 1Z0-066 Your Data Guard environment has two remote physical standby databases. Client applications use the local naming method to define connectivity to the primary database instance. Which will automatically redirect clients to the new primary database in case of a switchover or failover? Create a database service on the standby databases; automate the start of the service after a role change, and modify the connection description on the clients to use that service. Configure a PRIMARY role service on the Primary and Standby and modify the Client connect descriptor to include both Primary and the Standby. Set the DB_NAME parameter identically on all databases; modify the connection descriptor on the clients to use DB_NAME to connect to the primary database instance. Set the LOCAL_LISTENER parameter for all the database instances, to register services with the default listener on the primary database host. 3 SC edit delete
36 1Z0-066 Which two are true about management of a far sync instance when using the Data Guard Broker? (Choose two.) A far sync instance is in a disabled state in the broker configuration immediately after adding it. A far sync instance that has its RedoRoutes property set may not be disabled in the broker configuration. Broker management of a far sync instance may only be disabled with the disable configuration DGMGRL command. A far sync instance need not exist before adding it to the broker configuration but may not be enabled until created. 1, 2 MC edit delete
35 1Z0-066 You must design an Oracle Data Guard configuration for an OLTP database that meets these permanent requirements: 35-quedg.png a primary database with three physical standby databases a primary database with one logical and two physical standby databases a primary database with one logical standby database a primary database with one logical and one physical standby database a primary database with two physical standby databases a primary database with one physical standby database 4 SC edit delete
34 1Z0-066 Which three are prerequisites for enabling Fast-Start Failover? (Choose three.) The Fast-Start Failover target standby database must receive REDO directly from the primary database. Flashback Database must be enabled on both the primary database and the Fast-Start Failover target standby database. Flashback Database must be enabled only on the Fast-Start Failover target standby database. The configuration must be operating in either Maximum Performance or Maximum Availability mode. The configuration must be operating in either Maximum Performance or Maximum Protection mode. The Data Guard environment must be managed by the Data Guard Broker. 2, 4, 6 MC edit delete
33 1Z0-066 Examine this list of possible steps: 33-quedg.png 5, 2, 4, 3, 6, 1 1, 5, 2, 4, 6, 3 5, 2, 4, 6, 3, 1 4, 6, 5, 2, 3, 1 5, 2, 4, 1 1 SC edit delete
32 1Z0-066 Which statement is true regarding Oracle Net connectivity for a Data Guard Broker configuration? To start SQL apply on a logical standby database, a TNS entry enabling connectivity to the primary database instance must be defined on the logical standby database host. the LOCAL_LISTENER initialization parameter must be set to the listener used to register the primary database instance. To enable Real_Time Query on a physical standby database, a TNS entry enabling connectivity to the standby database instance must be defined on the primary database host. A TNS enabling connectivity to the primary database instance must be defined on each of the standby database hosts. A TNS entry or entries enabling connectivity to standby database instance(s) must be defined on the primary database host. 4 SC edit delete
31 1Z0-066 Which three are true concerning restoring of RMAN backups to primary and physical standby databases in a Data Guard environment? (Choose three.) Backups of data files taken on the primary database may be restored on a physical standby database. Backups of control files taken on the primary database may not be restored and used on a physical standby database. Backups of SPFILEs taken on a physical standby database may not be restored on the primary database. Backups of control files taken on a physical standby database may be restored on the primary database. Backups of data files taken on a physical standby database may be restored on a primary database. Backups of SPFILEs taken on the primary database may not be restored and used on a physical standby database. 3, 5, 6 MC edit delete
30 1Z0-066 Examine the Fast-start configuration: 30-quedg.png The observer will initiate a failover when the primary database is unable to produce local archived redo log files. An automatic failover will be initiated even if the target standby database lags behind the primary. The observer is running. A failover may occur if the observer has lost connectivity to the primary database, even if the Fast-Start Failover target standby database has a good connection to the primary database. The configuration operates in Maximum Availability mode. The configuration operates in Maximum Performance mode. 1, 3, 5 MC edit delete
29 1Z0-066 Which three are required in order to use Real-Time Query without lagging behind the primary? (Choose three.) There must be standby redo logs on the standby database. There must be standby redo logs on the primary database. The primary must ship redo asynchronously. COMPATIBLE must be set to 11.1.0 or higher. Real-Time apply must be enabled on the standby. 1, 4, 5 MC edit delete
28 1Z0-066 Which three steps are prerequisites for the creation of a physical standby database on a separate server using the RMAN active database duplication method?(Choose three.) Set the DB_UNIQUE_NAME parameter on the primary database to a different value than that of the DB_NAME parameter. Put the primary database into archivelog mode. Startup nomount the standby database instance. Configure Oracle Net connectivity on the primary host to the standby database instance. Establish user equivalence for the database software owner between the primary host and standby host. 3, 4, 5 MC edit delete
27 1Z0-066 Which two are true about the use of RMAN recovery catalogs when offloading backups to a physical standby database? (Choose two.) It backups that are offloaded to a physical standby database are taken when not connected to a recovery catalog, then they may still be used for restoration on the primary database. The physical standby database may be used to register the database in the recovery catalog, if the primary is not registered. The primary and physical standby databases must be registered separately in the recovery catalog, if a far sync instance is used to route redo to the physical standby database. It is not necessary to use a recovery catalog unless a far sync instance is used to route redo to the physical standby database. Primary and physical standby database may use different virtual recovery catalogs in the same physical recovery catalog. 4, 5 MC edit delete
26 1Z0-066 A Data Guard environment has this configuration and these attributes: 26-quedg.png The sequence is usable on physt1 and physt2. The sequence is usable on physt1 but not usable on physt2. The sequence is usable on physt2 if physt1 becomes unavailable, but only if an alternative redo destination has been configured on the primary database. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on the primary database. physt2 will no longer receive redo if physt1 becomes unavailable, unless LOG_ARCHIVE_DEST_n has the ALTERNATE attribute specified on physt1. 3, 5 MC edit delete
25 1Z0-066 Which two are prerequisites for creating a standby database using Enterprise Manager cloud control? (Choose two.) The primary database must have FORCE LOGGING enabled. The primary database must be in archivelog mode. A backup of the primary database must exist. The primary host and the proposed standby database host must run the same operating system. The primary database instance must be started using an SPFILE. The primary database must have flashback enabled. 1, 2 MC edit delete
24 1Z0-066 Which three are always benefits of using a logical standby database? (Choose three.) It can be used for database rolling release upgrades. It can be used to replicate a single pluggable database (PDB) in a multitenant container database. It can be used as an updatable database for Real Applicationt Testing and then converted back to a standby database without affecting the updates. It can be used for reporting workloads requiring additional indexes or materialized views or both. It provides a disaster-recovery solution with switchover and failover options that can recover any data updated on the primary database. It can be used for testing patchsets without affecting the primary database. 3, 4, 6 MC edit delete
23 1Z0-066 Which three are benefits of using the Data Guard Broker to manage standby databases? (Choose three.) It simplifies physical standby database creation. It provides an easy failover capability using a single command. It coordinates database state transitions and updates database properties dynamically. It automatically changes database properties after the protection mode for a configuration is changed. It provides an easy switchover capability using a single command. It simplifies logical standby database creation. It load balances connections between the primary and all the standby database instances that are open as read-only for reporting. 2, 3, 5 MC edit delete
22 1Z0-066 Which three statements are true about snapshot standby databases? (Choose three.) Tablespaces can be dropped. Tables can be dropped. The broker may be used to fail over to a snapshot standby database. A logical standby database can be converted into a snapshot standby database. Tablespaces can be created. 1, 2, 5 MC edit delete
21 1Z0-066 Which three statements are true about Far Sync instances? (Choose three.) The Data Guard Broker must be used to deploy and manage Far Sync instances. They enable standby databases to be configured at remote distances from the primary without impacting performance on the primary. A primary database can ship redo directly to multiple Far Sync instances. They use an spfile, a standby controlfile, and standby redo logs. They work with any protection level. 1, 2, 4 MC edit delete
20 1Z0-066 Which two are true about the usage of DBMS_ROLLING? (Choose two.) The leading group contains the original primary database. The trailing group contains the original primary database. The background process DMON must be enabled on all database instances that take part in the rolling release upgrade process. At least one logical standby database must be part of the initial Data Guard configuration. The trailing group can contain standby databases that will protect the original primary database during the rolling release upgrade process. 4, 5 MC edit delete
19 1Z0-066 In which two cases is it possible to change the protection mode to maximum protection using Enterprise Manager Cloud Control? (Choose two.) A snapshot standby database is the only standby database in the Data Guard configuration. A logical standby database is the only standby database in the data guard configuration. A far sync instance is the only Data Guard configuration member receiving redo in synchronous mode. Flashback is not enabled for either the primary database, the standby database, or both in the Data Guard configuration. The primary and standby databases are hosted on different operating systems. 2, 5 MC edit delete
18 1Z0-066 You created a physical standby database PRODSBY1 from the primary database PROD using SQL and RMAN. Which two are prerequisites for creating a Data Guard Broker configuration to manage these databases? (Choose two.) The standby database must have supplemental logging enabled. The primary database must have FORCE LOGGING enabled. The DG_BROKER_START parameter must be set to TRUE for both database instances. The primary database must have supplemental logging enabled. A local net service name to enable connectivity to the PRODSBY1 database instance must be defined on the primary database host. 2, 3 MC edit delete
17 1Z0-066 Which three are true regarding the Enterprise Manager Cloud Control Data Guard configuration verification wizard? (Choose three.) It checks that supplemental logging is turned on if there is a logical standby database in the configuration. It verifies that parameter settings in the SPFILE or in memory or both, are consistent with the broker configuration properties for that database. It checks that the current data protection level is consistent with the broker’s configured data protection mode. It modifies the database configurable parameters to match the values set for the broker configuration. It generates a workload on the primary database causing log switching, and monitors the arrival rate of redo on the standby database. 1, 2, 3 MC edit delete
16 1Z0-066 You are licensed to use Oracle Active Data Guard. Which two statements are true after enabling block change tracking on a physical standby database? (Choose two.) It allows fast incremental backups to be offloaded to the physical standby database. It starts the CTWR process on the physical standby database instance. It allows fast incremental backups to be taken on the primary database. It starts the RVWR process on the physical standby database instance. It allows fast incremental backups to be offloaded to a snapshot standby database, when the physical standby database in converted. It starts the CTWR process on the primary database instance. 1, 2 MC edit delete
15 1Z0-066 A query on the view DBA_LOGSTDBY_UNSUPPORTED on your primary database returns several rows. 15-quedg.png The upgrade requires downtime until the upgrade of the standby is completed. The broker must be disabled during the upgrade. With manual upgrade, catupgrd.sql can be executed on the primary and standby databases simultaneously. The upgrade requires downtime until the upgrade of the primary is completed. The new release of the Oracle Software must be installed on both the primary and standby database hosts. Redo Apply on the standby database must be stopped while the primary database is upgraded. Fast-Start Failover can be used to protect the primary database during the upgrade. 2, 4, 5 MC edit delete
14 1Z0-066 Which four requirements can be met by deploying a logical standby database? (Choose four.) Support for workloads requiring additional indexes. It can be used to create additional schemas. It can be used to create additional tables. It must have the same physical structure as the primary database. It must provide a disaster-recovery solution that protects all data with capability of performing switchovers and failovers. Support for workloads requiring additional materialized views. It can be used for Real Application Testing without affecting the disaster recovery capabilities. 1, 3, 5, 7 MC edit delete
13 1Z0-066 After converting your physical standby database to a logical database, you get an error: 13-quedg.png Add a logical standby database PRODSBY and enable it, thereby replacing the physical standby database metadata in the broker configuration. Remove the physical standby database PRODSBY from the broker configuration, add a logical standby database PRODSBY to the broker configuration and enable it. Reinstate the physical standby database PRODSBY as a logical standby, thereby replacing the physical standby database metadata in the broker configuration. Reinstate both the primary and physical standby databases. The broker will automatically detect that PRODSBY is a logical standby update to the metadata. 4 SC edit delete
12 1Z0-066 You are monitoring your Data Guard broker configuration and issue this set of DGMGRL commands: 12-quedg.png The Close_by primary database instance forwards redo to the FS_inst Far Sync instance, which forwards the redo in turn to the Far_away physical standby database instance. The far sync instance will not forward redo to the Far_away physical standby because the Protection mode is not MaxProtection. The close_by primary database forwards redo to the Far_away physical standby directly and also sends redo to the FS_inst Far Sync instance. The far sync instance will not forward redo to the Far_away physical standby because Fast-Start Failover is disabled. The FS_inst Far Sync instance forwards redo to the Far_away physical standby only if the close_by primary database is not able to do so. 1 SC edit delete
11 1Z0-066 Which three statements are true about Global Sequences when connected to a physical standby database with Real-Time Query enabled? (Choose three.) If the CACHE option is set then the size of the cache must be at least 100. Their creation requires that a LOG_ARCHIVE_DEST_n parameter be defined in the standby that points back to their primary. Their usage will always have a performance impact on the primary database. Their usage may have a performance impact on the physical standby database if the CACHE size is too small They must have the NOORDER and CACHE options set. 2, 4, 5 MC edit delete
10 1Z0-066 Which three statements are true about snapshot standby databases? (Choose three.) Snapshot standby databases may be used for rolling release upgrades. If datafiles grow while a database is a snapshot standby database, then they shrink when converted back to a physical standby database. Flashback logs are used to convert a snapshot standby database back into a physical standby database. A snapshot standby database can have Real-Time Query enabled. A guaranteed restore point is created automatically when a physical standby database is converted into a snapshot standby database. 2, 3, 5 MC edit delete
9 1Z0-066 There are currently 6 APPLIER and 6 PREPARER processes running and no idle APPLIER processes on your logical standby database. 09-quedg.png Increase the PROCESSES initialization parameter Increase the value for the MAX_SERVERS SQL apply parameter. Decrease the number of archiver processes on the standby database. Increase the PARALLEL_MAX_SERVER initialization parameter Decrease the number of PREPARER processes Increase the RECOVERY_PARALLELISM initialization parameter 2, 5 MC edit delete
8 1Z0-066 Which two are true about database roles in an Oracle Data Guard Configuration? (Choose two.) A configuration consisting only of a primary and one or more physical standby databases can support a rolling release upgrade. A Logical Standby Database can be converted to a Snapshot Standby Database. A Logical Standby Database can cascade redo to a terminal destination. A Snapshot Standby Database can be a fast-start failover target. A Physical Standby Database can be converted into a Logical Standby Database. 2, 5 MC edit delete
7 1Z0-066 Which four factors can influence the rate of SQL apply on a logical standby database? (Choose four.) The size of the undo tablespace on the logical standby database The number of full table scans performed by SQL apply The number of coordinator processes on the standby database instance The size of the shared pool The number of APPLIER processes The number of PREPARER processes 2, 4, 5, 6 MC edit delete
6 1Z0-066 You administer a Data Guard environment consisting of a primary database and three physical standby databases. 06-quedg.png CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY; CONFIGURE ACHIVELOG DELETION POLICY TO APPLIED ON STANDBY; CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY; CONFIGURE ACHIVELOG DELETION POLICY TO SHIPPED TO STANDBY; CONFIGURE ACHIVELOG DELETION POLICY TO NONE; 2 SC edit delete
5 1Z0-066 A data file on one of your physical standby databases has been accidentally deleted and you must restore and recover it. 05-quedg.png Recover the datafile by using the RMAN RECOVER DATAFILE command Restart the redo apply. Restore the datafile by using the RMAN RESTORE DATAFILE command. Stop the redo apply. Recover the database by using the RMAN RECOVER DATABASE command. 3, 4, 5 MC edit delete
4 1Z0-066 Examine the Data Guard configuration: 04-quedg.png The switchover succeeds but Dogs need to be reinstated. The switchover succeeds but Fast-Start Failover is suspended. The switchover succeeds and Cats become the new failover target. The switchover succeeds and Dogs become the new failover target. It results in an error indicating that a switchover is not allowed. 4 SC edit delete
3 1Z0-066 Attempting to start the observer raises an error: 03-quedg.png Fast-Start Failover is not yet enabled for this Data Guard configuration. The observer configuration file is marked read-only. There is already an observer running for this Data Guard configuration. There is another observer running for a Data Guard configuration which uses the same observer configuration file. The broker configuration has not yet been created. 2, 4 MC edit delete
2 1Z0-066 Examine the Data Guard configuration: 02-quedg.png DGMGRL> convert database cats to physical standby; DGMGRL> convert database sheep to physical standby; DGMGRL> convert database sheep to physical standby; DGMGRL> convert database cats to physical standby; DGMGRL>edit configuration set protection mode as maxperformance; DGMGRL> convert database sheep to physical standby; None, because you can directly failover to a Snapshot Standby Database. 5 SC edit delete
1 1Z0-066 You must configure an Oracle Data Guard environment consisting of: 01-quedg.png SYNC NOAFFIRM and Maximum Protection SYNC NOAFFIRM and Maximum Availability ASYNC and Maximum Performance SYNC AFFIRM and Maximum Availability SYNC AFFIRM and Maximum Protection 4 SC edit delete

Copyright © Designed & Developed by Sakthi Db Technology 2018